UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZeuQ89hsUjqw3zOzTy7Mgeh0mZyaFYSIIEQOnumXltA=' 
WHERE 
  key_id = '3c968f40fcf5b5ca7902b49b97367a08f8c4ba2c10a2564146f0d9535f8dff76' 
  AND (
    token = 'ZeuQ89hsUjqw3zOzTy7Mgeh0mZyaFYSIIEQOnumXltA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028