UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iQIS2n4Ys4l+UJsxhpcAzXY5ijvAq/7pl2kB2rH9PEE=' 
WHERE 
  key_id = 'c5f4984636ebd69fcb903fea087635253a485041a5e09dc14026880ba7025737' 
  AND (
    token = 'iQIS2n4Ys4l+UJsxhpcAzXY5ijvAq/7pl2kB2rH9PEE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045