UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/fLp4h2MshEgGJ7CZm7map7JYtYspLPYs49wWWr/U0k='
WHERE
key_id = '8e4e5e5368a4bf60d1f4d40dee235cc98ddc8c83e057986f8261788eed03bedb'
AND (
token = '/fLp4h2MshEgGJ7CZm7map7JYtYspLPYs49wWWr/U0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)