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