UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's6eHAv9WOe09B9ERm48TtsltmcUHEgIOUP2tn8V86Dk='
WHERE
key_id = 'ce423c20ba74efc0d28f521f642ac41dd0ffb2cbac0abe0d6b15e1e74cde3370'
AND (
token = 's6eHAv9WOe09B9ERm48TtsltmcUHEgIOUP2tn8V86Dk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)