UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EsN9jf29RFbIcFR55rPp0ZJkOu0nUt0EJSgsDsKWh3Q='
WHERE
key_id = '9d94f12cc1df982a7911510db736a21b071044e94762c746d0486e81023881b0'
AND (
token = 'EsN9jf29RFbIcFR55rPp0ZJkOu0nUt0EJSgsDsKWh3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)