UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aY1pIjm9wusHNU1rod4m10c2I3NhK7KkQdMszTGDVEs='
WHERE
key_id = '610ae5f97db763f58c809ac2d66e2afb74be7784e472a4d680ddf9713a66b278'
AND (
token = 'aY1pIjm9wusHNU1rod4m10c2I3NhK7KkQdMszTGDVEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)