UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JG+XQlvZf2HJ9LBUvxrO+xDMs7TXOw2j0hJ5evuqbDI='
WHERE
key_id = 'ce148c26b1ea866e9055ab549204e151d09db52fde892f2816df12a0798766bf'
AND (
token = 'JG+XQlvZf2HJ9LBUvxrO+xDMs7TXOw2j0hJ5evuqbDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)