UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pubxUw85xg29BaOc7yYNF3v0HMCEmyp1S1n2zPaYD1M='
WHERE
key_id = 'f0ae1cf38db020cb3d8a1a613e21c13f7750f02414284196126a1f0722c0acd3'
AND (
token = 'pubxUw85xg29BaOc7yYNF3v0HMCEmyp1S1n2zPaYD1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)