UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yxi5CS5FdXKQk/crjaVB+ZCLiUJvI6p53h9pIxiYNaw=' 
WHERE 
  key_id = 'a3d47154d632eca9c2253a58a6672f33a5b7227f8d436bb6910bc778201af8e3' 
  AND (
    token = 'yxi5CS5FdXKQk/crjaVB+ZCLiUJvI6p53h9pIxiYNaw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030