UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Z++K4rHbvTe816qaNhOEnRTUijKEDZ/4nSVN91ikaY='
WHERE
key_id = '10b1f5afc7e7e5387a07c7a94a342db8580b10f11f5203b3a57df586a2f9d401'
AND (
token = '1Z++K4rHbvTe816qaNhOEnRTUijKEDZ/4nSVN91ikaY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)