UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6/vWZ8oDx+sURaEGcJsEZn6dv6zFFPGk069j+ieaYAA=' 
WHERE 
  key_id = 'd05eedfa028a03f11bbea5b7f7de3ed2c45ff85ed9d6b19fa26a0b27f490fc0e' 
  AND (
    token = '6/vWZ8oDx+sURaEGcJsEZn6dv6zFFPGk069j+ieaYAA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022