UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XlfO1Yl6ntY9V7XBEZrnhYGkR8hAMRb0kj1b2lrLaso=' 
WHERE 
  key_id = '43d2bc244ae3f4783d9afcd52c1c229061396c28f6d7aa14fac61f1cd4f4987c' 
  AND (
    token = 'XlfO1Yl6ntY9V7XBEZrnhYGkR8hAMRb0kj1b2lrLaso=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024