UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CWL6pRVeNmGDCSmSdlYC+nuCrXg712HQPga5LzRNg7I='
WHERE
key_id = '49e6925ca83163510d1b10eca7f9f9b792f7911f048125a33bbfecd76f493694'
AND (
token = 'CWL6pRVeNmGDCSmSdlYC+nuCrXg712HQPga5LzRNg7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)