UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YgF6gAlWxQwXjH0+rZ9IZhy6tBev6AOOULMjyGAzGB4=' 
WHERE 
  key_id = '8dbd22a0082584e7765a0c276ff4430f6d0f95f367add7734b336b7613623735' 
  AND (
    token = 'YgF6gAlWxQwXjH0+rZ9IZhy6tBev6AOOULMjyGAzGB4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025