UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XlWTxYyxVWXFyEFmGJenbgMS7v/E98J2UjYXJAttZlw=' 
WHERE 
  key_id = 'cce7a7cade17e6bb2cc75113ae08f1f99d1337f4571233a2634b3274f6ffc628' 
  AND (
    token = 'XlWTxYyxVWXFyEFmGJenbgMS7v/E98J2UjYXJAttZlw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032