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