UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FC7V5b/Qqr7mcE1VBnWbSRMwWhSzLvwATBlxtguZTVE='
WHERE
key_id = 'bc9b9ac9f83ae7493724a05929c6f9acdd642912c4364956238b153de887c4b9'
AND (
token = 'FC7V5b/Qqr7mcE1VBnWbSRMwWhSzLvwATBlxtguZTVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)