UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9YWZLznF4IeZUa+G7bhv+7m8rI1HKrMMjftoNJcTYn4='
WHERE
key_id = '2a3e489c094ca8512eee8e7b675f77c2d5f833f048478e64480dda722f2220e3'
AND (
token = '9YWZLznF4IeZUa+G7bhv+7m8rI1HKrMMjftoNJcTYn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)