UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QhmWCo4/81l9/8cMpR2sKBbjJ4K9D6Wij1xTtaRO5Uk='
WHERE
key_id = 'c114240e3aeaddd726a06ce0f54aa2e8b3c75ee8cec731c7843216705f15f1ec'
AND (
token = 'QhmWCo4/81l9/8cMpR2sKBbjJ4K9D6Wij1xTtaRO5Uk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)