UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ApGBcUAZUe6Jh9GUl/YGxyAw9nPrZTFtzcojLHlk+JI='
WHERE
key_id = 'bdb81abc33c84aac0b6b2aa9c12025b4104f50bc78d762e9fa22b372dff83b47'
AND (
token = 'ApGBcUAZUe6Jh9GUl/YGxyAw9nPrZTFtzcojLHlk+JI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)