UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JzXo2HNFWFaMbnaMmyDHi0N+xbP+1bOTcu+1IZrTwL0='
WHERE
key_id = '65ddbcbfb3db259096e5a6438332fab884de9e1cf73a00ad5d38d9bfa5d4a7c1'
AND (
token = 'JzXo2HNFWFaMbnaMmyDHi0N+xbP+1bOTcu+1IZrTwL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)