UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XW9SqQjqnKjplM2uMVUnPV2KL1tRjJATm0h1ZetyNsI='
WHERE
key_id = '604855ca2b622bf04776a9c30003dce7613d7962fd31587b767fa2980f9a4603'
AND (
token = 'XW9SqQjqnKjplM2uMVUnPV2KL1tRjJATm0h1ZetyNsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)