UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5kVKSE5b0hhosEakv7SkXzKKbPATppO3thxvShW0jVc='
WHERE
key_id = 'ab51e3ea9380b362ad7aa82d4f5ed5f77a54437da54a3dc19be8b43b5c6536a7'
AND (
token = '5kVKSE5b0hhosEakv7SkXzKKbPATppO3thxvShW0jVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)