UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Dd9Fbzw8HNpIb+n7Ej8/1fN5ACwJ1SxBewi+MycZ0CE=' 
WHERE 
  key_id = 'b58d21d5e8ea2748b3eeadda34f5a6cca1856c04fe3d736c970134607fcd072c' 
  AND (
    token = 'Dd9Fbzw8HNpIb+n7Ej8/1fN5ACwJ1SxBewi+MycZ0CE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022