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