UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nf9ruyF+10fZNwEAXTkp2UDinSHYuDuIdA3cnuWjDi0='
WHERE
key_id = 'ffa83ebe59309646c4000d317dc1b9c9244563440285878cf6093f6daa50760b'
AND (
token = 'nf9ruyF+10fZNwEAXTkp2UDinSHYuDuIdA3cnuWjDi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)