UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kZ7kuC6FuKpldIkPS9X2pvQ/rKZUvdz1CHNfiIK6cU8='
WHERE
key_id = 'cb4fbf95cfd49254d2842ee8bb65bdce70b6e5613aa612d3f2b65571b63561e5'
AND (
token = 'kZ7kuC6FuKpldIkPS9X2pvQ/rKZUvdz1CHNfiIK6cU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)