UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CmeyKkaOUE5/zVz+eSaB8khiKIhW7LIL9159PWGSckc='
WHERE
key_id = 'd98b71427b2ea3272b7fd8c2adf1de292721f2d97bb0e3c188fbb3ca270bb323'
AND (
token = 'CmeyKkaOUE5/zVz+eSaB8khiKIhW7LIL9159PWGSckc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)