UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qUHp/0R6CpZw3Er0ysXOcZHkXX29YxyZmtASDtHCYYo=' 
WHERE 
  key_id = '8ebaedba7a43646a9ef238637ea47af0f2a5aac6dea17e984a363f72e1aac4f9' 
  AND (
    token = 'qUHp/0R6CpZw3Er0ysXOcZHkXX29YxyZmtASDtHCYYo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047