UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mBqZc7V/VH2PLv4+K9D10YSPQHCpdN/iiFftY/wLjo0='
WHERE
key_id = '28ee86f949327ca975ddd7f52885a81773943ad0a186ffe31d0366739b61d00a'
AND (
token = 'mBqZc7V/VH2PLv4+K9D10YSPQHCpdN/iiFftY/wLjo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)