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