UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HkYUVzY8VzJixM67/30xxfJETOdeZ2uBXpYw7+bMIS4=' 
WHERE 
  key_id = '4b5f47f5a6f49f24aab4786e9a40a7f3ae9b2ee215596246b7e45d9d519830dc' 
  AND (
    token = 'HkYUVzY8VzJixM67/30xxfJETOdeZ2uBXpYw7+bMIS4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022