UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iZmya/S8LOhCwWp3vm9msOxgRqU5B07nWNxeBYNyiw0='
WHERE
key_id = 'b15006e14f52e71a204279e55e7c7169f283147fdaa4b53d9f2035d65f38cd9d'
AND (
token = 'iZmya/S8LOhCwWp3vm9msOxgRqU5B07nWNxeBYNyiw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)