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