UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XxSx82cCQeAXJiB+M/z9iBIsqp5WkV6i+oHOlo//nbw=' 
WHERE 
  key_id = 'f7872b5636500b85f7dd8fd02d0f613159f0e24cb24c29c33f95a94672faae55' 
  AND (
    token = 'XxSx82cCQeAXJiB+M/z9iBIsqp5WkV6i+oHOlo//nbw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00054