UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FmN6W4KzbAQ0CKINQvW4X+2ZJ9/4tN/IkB5gcioGPPE=' 
WHERE 
  key_id = 'b1a8872c0596640f926df92e5f8fed1b58977e0ff319b6894453af71f746182b' 
  AND (
    token = 'FmN6W4KzbAQ0CKINQvW4X+2ZJ9/4tN/IkB5gcioGPPE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026