UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hEPByf2Vdie0uRw3MEvhiMp9wzhLvbEb2uI4LLxgOTQ='
WHERE
key_id = '8f4a5ff93508b4e086fa9ec27d624395a91d22ebaca77e0e9d8fa37df6ff754f'
AND (
token = 'hEPByf2Vdie0uRw3MEvhiMp9wzhLvbEb2uI4LLxgOTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)