UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A1SZWD3pC4WXx9HEDQAlemFwiLjDwOstUtG4ecsw8YE='
WHERE
key_id = '04d6ad6f42eb7fc6ef06b700d5ee6acf5fb6f4af5cc7501ac36f91cf385413bf'
AND (
token = 'A1SZWD3pC4WXx9HEDQAlemFwiLjDwOstUtG4ecsw8YE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)