UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v4N8IhExomtoJGbAzgCVejh9Ng28Ru7HmakHVrIl9yg='
WHERE
key_id = 'a42a779690083de0baeda045c879f2d9499942f075a1e5b1f932f5f44d6ebafe'
AND (
token = 'v4N8IhExomtoJGbAzgCVejh9Ng28Ru7HmakHVrIl9yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)